Tabela CO_SUBSCRIPTION

Definicja tabeli CO_SUBSCRIPTION

Name

CO_SUBSCRIPTION

Code

CO_SUBSCRIPTION

Comment

 


Lista kolumn tabeli CO_SUBSCRIPTION

Name

Code

CO_SUBSCRIPTIONID

CO_SUBSCRIPTIONID

RESOURCEID

RESOURCEID

TOTALPRICE

TOTALPRICE

STARTDATE

STARTDATE

CREATEDATE

CREATEDATE

PAID

PAID

CLOSED

CLOSED

CO_SUBSCRIPTIONPERSONID

CO_SUBSCRIPTIONPERSONID

REFUNDTOTAL

REFUNDTOTAL

TOPAID

TOPAID

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_SUBSCRIPTIONID tabeli CO_SUBSCRIPTION

Definicja kolumny CO_SUBSCRIPTIONID tabeli CO_SUBSCRIPTION

Name

CO_SUBSCRIPTIONID

Code

CO_SUBSCRIPTIONID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna RESOURCEID tabeli CO_SUBSCRIPTION

Definicja kolumny RESOURCEID tabeli CO_SUBSCRIPTION

Name

RESOURCEID

Code

RESOURCEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TOTALPRICE tabeli CO_SUBSCRIPTION

Definicja kolumny TOTALPRICE tabeli CO_SUBSCRIPTION

Name

TOTALPRICE

Code

TOTALPRICE

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna STARTDATE tabeli CO_SUBSCRIPTION

Definicja kolumny STARTDATE tabeli CO_SUBSCRIPTION

Name

STARTDATE

Code

STARTDATE

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna CREATEDATE tabeli CO_SUBSCRIPTION

Definicja kolumny CREATEDATE tabeli CO_SUBSCRIPTION

Name

CREATEDATE

Code

CREATEDATE

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna PAID tabeli CO_SUBSCRIPTION

Definicja kolumny PAID tabeli CO_SUBSCRIPTION

Name

PAID

Code

PAID

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna CLOSED tabeli CO_SUBSCRIPTION

Definicja kolumny CLOSED tabeli CO_SUBSCRIPTION

Name

CLOSED

Code

CLOSED

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna CO_SUBSCRIPTIONPERSONID tabeli CO_SUBSCRIPTION

Definicja kolumny CO_SUBSCRIPTIONPERSONID tabeli CO_SUBSCRIPTION

Name

CO_SUBSCRIPTIONPERSONID

Code

CO_SUBSCRIPTIONPERSONID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna REFUNDTOTAL tabeli CO_SUBSCRIPTION

Definicja kolumny REFUNDTOTAL tabeli CO_SUBSCRIPTION

Name

REFUNDTOTAL

Code

REFUNDTOTAL

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna TOPAID tabeli CO_SUBSCRIPTION

Definicja kolumny TOPAID tabeli CO_SUBSCRIPTION

Name

TOPAID

Code

TOPAID

Data Type

NUMBER(38,2)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_SUBSCRIPTION

Definicja kolumny INSERTDATE tabeli CO_SUBSCRIPTION

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_SUBSCRIPTION

Definicja kolumny INSERTINGPERSON tabeli CO_SUBSCRIPTION

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_SUBSCRIPTION

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_SUBSCRIPTION

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_SUBSCRIPTION

Definicja kolumny LASTMODIFIEDDT tabeli CO_SUBSCRIPTION

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_SUBSCRIPTION

Name

Code

Primary

PK_CO_SUBSCRIPTION

PK_CO_SUBSCRIPTION

X


Klucz PK_CO_SUBSCRIPTION tabeli CO_SUBSCRIPTION

Definicja klucza PK_CO_SUBSCRIPTION tabeli CO_SUBSCRIPTION

Name

PK_CO_SUBSCRIPTION

Code

PK_CO_SUBSCRIPTION

Primary

Yes

Comment